---
title: WorksheetFunction.Imaginary Method (Excel)
keywords: vbaxl10.chm137286
f1_keywords:
- vbaxl10.chm137286
ms.prod: excel
api_name:
- Excel.WorksheetFunction.Imaginary
ms.assetid: 4699b454-7bdd-42d3-b363-a7a07341de3d
ms.date: 06/08/2017
---


# WorksheetFunction.Imaginary Method (Excel)

Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.


## Syntax

 _expression_ . **Imaginary**( **_Arg1_** )

 _expression_ A variable that represents a **WorksheetFunction** object.


### Parameters



|**Name**|**Required/Optional**|**Data Type**|**Description**|
|:-----|:-----|:-----|:-----|
| _Arg1_|Required| **Variant**|Inumber - a complex number for which you want the imaginary coefficient.|

### Return Value

Double


## Remarks




- Use COMPLEX to convert real and imaginary coefficients into a complex number.
    

## See also


#### Concepts


[WorksheetFunction Object](worksheetfunction-object-excel.md)

